select col8 , lead(col8) over(partition by col7 order by col8 desc) lead_col8 from "allTypsUniq.parquet"